/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : localhost:3306
 Source Schema         : ff_boot_init

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 18/12/2019 11:04:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_dept
-- ----------------------------
DROP TABLE IF EXISTS `t_dept`;
CREATE TABLE `t_dept` (
                        `DEPT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门ID',
                        `PARENT_ID` bigint(20) NOT NULL COMMENT '上级部门ID',
                        `DEPT_NAME` varchar(100) NOT NULL COMMENT '部门名称',
                        `ORDER_NUM` double(20,0) DEFAULT NULL COMMENT '排序',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`DEPT_ID`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_dept
-- ----------------------------
BEGIN;
INSERT INTO `t_dept` VALUES (1, 0, '开发部', 1, '2018-01-04 15:42:26', '2019-01-05 21:08:27');
INSERT INTO `t_dept` VALUES (4, 0, '市场部', 2, '2018-01-04 15:42:36', '2019-01-23 06:27:56');
INSERT INTO `t_dept` VALUES (9, 0, '运营部', 3, '2019-12-12 16:59:25', NULL);
INSERT INTO `t_dept` VALUES (10, 0, '产品部', 4, '2019-12-12 16:59:48', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_dict
-- ----------------------------
DROP TABLE IF EXISTS `t_dict`;
CREATE TABLE `t_dict` (
                        `DICT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典ID',
                        `KEYY` bigint(20) NOT NULL COMMENT '键',
                        `VALUEE` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '值',
                        `FIELD_NAME` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '字段名称',
                        `TABLE_NAME` varchar(500) COLLATE utf8mb4_bin NOT NULL COMMENT '表名加备注',
                        PRIMARY KEY (`DICT_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_dict
-- ----------------------------
BEGIN;
INSERT INTO `t_dict` VALUES (1, 0, '男', 'ssex', 't_user');
INSERT INTO `t_dict` VALUES (2, 1, '女', 'ssex', 't_user');
INSERT INTO `t_dict` VALUES (3, 2, '保密', 'ssex', 't_user');
INSERT INTO `t_dict` VALUES (4, 1, '有效', 'status', 't_user');
INSERT INTO `t_dict` VALUES (5, 0, '锁定', 'status', 't_user');
INSERT INTO `t_dict` VALUES (6, 0, '菜单', 'type', 't_menu');
INSERT INTO `t_dict` VALUES (7, 1, '按钮', 'type', 't_menu');
INSERT INTO `t_dict` VALUES (30, 0, '正常', 'status', 't_job');
INSERT INTO `t_dict` VALUES (31, 1, '暂停', 'status', 't_job');
INSERT INTO `t_dict` VALUES (32, 0, '成功', 'status', 't_job_log');
INSERT INTO `t_dict` VALUES (33, 1, '失败', 'status', 't_job_log');
INSERT INTO `t_dict` VALUES (35, 1, '正常', 'member_status', 'member 用户状态');
INSERT INTO `t_dict` VALUES (36, 2, '冻结', 'member_status', 'member 用户状态');
INSERT INTO `t_dict` VALUES (37, 1, '普通用户', 'member_type', 'member 用户类型');
INSERT INTO `t_dict` VALUES (38, 2, 'VIP用户', 'member_type', 'member 用户类型');
COMMIT;

-- ----------------------------
-- Table structure for t_log
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log` (
                       `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
                       `USERNAME` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '操作用户',
                       `OPERATION` text COLLATE utf8mb4_bin COMMENT '操作内容',
                       `TIME` decimal(11,0) DEFAULT NULL COMMENT '耗时',
                       `METHOD` text COLLATE utf8mb4_bin COMMENT '操作方法',
                       `PARAMS` text COLLATE utf8mb4_bin COMMENT '方法参数',
                       `IP` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '操作者IP',
                       `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
                       `location` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '操作地点',
                       PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_log
-- ----------------------------
BEGIN;
INSERT INTO `t_log` VALUES (5, 'admin', '修改角色', 153, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=3, roleName=普通用户, remark=只可查看，好可怜哦, createTime=null, modifyTime=Thu Dec 12 15:54:40 CST 2019, createTimeFrom=, createTimeTo=, menuIds=2,10,24,136,148,149,150,151,152,153)\"', '127.0.0.1', '2019-12-12 15:54:41', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (6, 'admin', '修改角色', 237, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=3, roleName=普通用户, remark=只可查看，好可怜哦, createTime=null, modifyTime=Thu Dec 12 15:55:19 CST 2019, createTimeFrom=, createTimeTo=, menuIds=1,3,11,12,13,130,135,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,163,164,165,166,167,2,10,24,136,148,149,150,151,152,153)\"', '127.0.0.1', '2019-12-12 15:55:19', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (7, 'admin', '删除角色', 125, 'cn.toma.controller.sys.RoleController.deleteRoles()', ' roleIds: \"2\"', '127.0.0.1', '2019-12-12 15:55:36', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (8, 'admin', '新增角色', 174, 'cn.toma.controller.sys.RoleController.addRole()', ' role: \"Role(roleId=73, roleName=测试员, remark=测试, createTime=Thu Dec 12 16:02:58 CST 2019, modifyTime=null, createTimeFrom=null, createTimeTo=null, menuIds=1,3,11,12,13,130,135,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,163,164,165,166,167)\"', '127.0.0.1', '2019-12-12 16:02:58', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (9, 'admin', '修改角色', 152, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=73, roleName=测试员, remark=测试, createTime=null, modifyTime=Thu Dec 12 16:08:50 CST 2019, createTimeFrom=, createTimeTo=, menuIds=1,3,11,12,13,130,135,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,163,164,165,166,167)\"', '127.0.0.1', '2019-12-12 16:08:51', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (10, 'admin', '修改菜单/按钮', 79, 'cn.toma.controller.sys.MenuController.updateMenu()', ' menu: \"Menu(menuId=11, parentId=3, menuName=新增用户, path=null, component=null, perms=user:add, icon=null, type=1, orderNum=0.0, createTime=null, modifyTime=Thu Dec 12 16:18:07 CST 2019, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-12 16:18:08', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (11, 'admin', '删除菜单/按钮', 196, 'cn.toma.controller.sys.MenuController.deleteMenus()', ' menuIds: \"160\"', '127.0.0.1', '2019-12-12 16:18:32', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (14, 'admin', '新增菜单/按钮', 38, 'cn.toma.controller.sys.MenuController.addMenu()', ' menu: \"Menu(menuId=168, parentId=2, menuName=百度一下, path=http://www.baidu.com, component=Layout, perms=, icon=, type=0, orderNum=2.0, createTime=Thu Dec 12 16:25:33 CST 2019, modifyTime=null, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-12 16:25:33', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (15, 'admin', '修改角色', 250, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=1, roleName=管理员, remark=管理员, createTime=null, modifyTime=Thu Dec 12 16:26:04 CST 2019, createTimeFrom=, createTimeTo=, menuIds=1,3,11,12,13,130,135,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,163,164,165,166,167,10,24,136,148,150,151,152,153,161,168,154,155,156,157,159)\"', '127.0.0.1', '2019-12-12 16:26:05', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (16, 'admin', '修改角色', 262, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=1, roleName=管理员, remark=管理员, createTime=null, modifyTime=Thu Dec 12 16:27:01 CST 2019, createTimeFrom=, createTimeTo=, menuIds=1,3,11,12,13,130,135,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,163,164,165,166,167,2,10,24,136,148,149,150,151,152,153,161,162,168,154,155,156,157,159)\"', '127.0.0.1', '2019-12-12 16:27:02', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (17, 'admin', '修改角色', 251, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=1, roleName=管理员, remark=管理员, createTime=null, modifyTime=Thu Dec 12 16:27:36 CST 2019, createTimeFrom=, createTimeTo=, menuIds=1,3,11,12,13,130,135,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,163,164,165,166,167,10,24,136,148,149,150,151,152,153,161,162,154,155,156,157,159)\"', '127.0.0.1', '2019-12-12 16:27:37', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (18, 'admin', '修改角色', 241, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=1, roleName=管理员, remark=管理员, createTime=null, modifyTime=Thu Dec 12 16:28:38 CST 2019, createTimeFrom=, createTimeTo=, menuIds=1,3,11,12,13,130,135,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,163,164,165,166,167,2,10,24,136,148,149,150,151,152,153,161,162,168,154,155,156,157,159)\"', '127.0.0.1', '2019-12-12 16:28:39', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (19, 'admin', '修改角色', 192, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=1, roleName=管理员, remark=管理员, createTime=null, modifyTime=Thu Dec 12 16:29:09 CST 2019, createTimeFrom=, createTimeTo=, menuIds=1,3,11,12,13,130,135,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,163,164,165,166,167,2,10,24,136,148,149,150,151,152,153,161,162,154,155,156,157,159)\"', '127.0.0.1', '2019-12-12 16:29:09', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (20, 'admin', '修改角色', 196, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=1, roleName=管理员, remark=管理员, createTime=null, modifyTime=Thu Dec 12 16:29:43 CST 2019, createTimeFrom=, createTimeTo=, menuIds=1,3,11,12,13,130,135,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,163,164,165,166,167,2,10,24,136,148,149,150,151,152,153,161,162,168,154,155,156,157,159)\"', '127.0.0.1', '2019-12-12 16:29:44', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (21, 'admin', '修改部门', 49, 'cn.toma.controller.sys.DeptController.updateDept()', ' dept: \"Dept(deptId=6, parentId=1, deptName=测试部, orderNum=4.0, createTime=null, modifyTime=Thu Dec 12 16:57:28 CST 2019, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-12 16:57:29', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (22, 'admin', '删除部门', 75, 'cn.toma.controller.sys.DeptController.deleteDepts()', ' deptIds: \"6,5\"', '127.0.0.1', '2019-12-12 16:57:43', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (23, 'admin', '新增部门', 23, 'cn.toma.controller.sys.DeptController.addDept()', ' dept: \"Dept(deptId=7, parentId=0, deptName=测试部门, orderNum=0.0, createTime=Thu Dec 12 16:58:07 CST 2019, modifyTime=null, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-12 16:58:08', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (24, 'admin', '新增部门', 17, 'cn.toma.controller.sys.DeptController.addDept()', ' dept: \"Dept(deptId=8, parentId=7, deptName=测试一部, orderNum=0.0, createTime=Thu Dec 12 16:58:17 CST 2019, modifyTime=null, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-12 16:58:18', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (25, 'admin', '删除部门', 13, 'cn.toma.controller.sys.DeptController.deleteDepts()', ' deptIds: \"8\"', '127.0.0.1', '2019-12-12 16:58:25', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (26, 'admin', '修改部门', 11, 'cn.toma.controller.sys.DeptController.updateDept()', ' dept: \"Dept(deptId=7, parentId=1, deptName=测试部门, orderNum=0.0, createTime=null, modifyTime=Thu Dec 12 16:58:34 CST 2019, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-12 16:58:34', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (27, 'admin', '修改部门', 11, 'cn.toma.controller.sys.DeptController.updateDept()', ' dept: \"Dept(deptId=7, parentId=1, deptName=测试部, orderNum=0.0, createTime=null, modifyTime=Thu Dec 12 16:59:06 CST 2019, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-12 16:59:06', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (28, 'admin', '新增部门', 22, 'cn.toma.controller.sys.DeptController.addDept()', ' dept: \"Dept(deptId=9, parentId=0, deptName=运营部, orderNum=3.0, createTime=Thu Dec 12 16:59:25 CST 2019, modifyTime=null, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-12 16:59:25', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (29, 'admin', '新增部门', 19, 'cn.toma.controller.sys.DeptController.addDept()', ' dept: \"Dept(deptId=10, parentId=0, deptName=产品部, orderNum=4.0, createTime=Thu Dec 12 16:59:48 CST 2019, modifyTime=null, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-12 16:59:48', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (30, 'admin', '删除菜单/按钮', 107, 'cn.toma.controller.sys.MenuController.deleteMenus()', ' menuIds: \"156\"', '127.0.0.1', '2019-12-12 17:03:58', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (31, 'admin', '删除菜单/按钮', 123, 'cn.toma.controller.sys.MenuController.deleteMenus()', ' menuIds: \"163\"', '127.0.0.1', '2019-12-12 17:35:09', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (32, 'admin', '删除菜单/按钮', 75, 'cn.toma.controller.sys.MenuController.deleteMenus()', ' menuIds: \"154\"', '127.0.0.1', '2019-12-12 17:35:42', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (33, 'admin', '删除系统日志', 83, 'cn.toma.controller.sys.LogController.deleteLogss()', ' ids: \"12\"', '127.0.0.1', '2019-12-12 17:39:26', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (34, 'admin', '删除系统日志', 14, 'cn.toma.controller.sys.LogController.deleteLogss()', ' ids: \"13\"', '127.0.0.1', '2019-12-12 17:39:43', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (35, 'admin', '修改用户', 67, 'cn.toma.controller.sys.UserController.updateUser()', ' user: \"User(userId=17, username=toma, password=null, deptId=1, deptName=开发部, email=toma@ffBoot.com, mobile=, status=1, createTime=null, modifyTime=Thu Dec 12 17:59:23 CST 2019, lastLoginTime=null, ssex=0, description=, avatar=default.jpg, roleId=73, roleName=管理员, sortField=, sortOrder=, createTimeFrom=, createTimeTo=, id=)\"', '127.0.0.1', '2019-12-12 17:59:23', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (36, 'admin', '修改角色', 154, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=73, roleName=测试员, remark=测试, createTime=null, modifyTime=Thu Dec 12 17:59:40 CST 2019, createTimeFrom=, createTimeTo=, menuIds=3,11,12,13,130,135,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,2,168)\"', '127.0.0.1', '2019-12-12 17:59:41', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (37, 'admin', '删除用户', 90, 'cn.toma.controller.sys.UserController.deleteUsers()', ' userIds: \"17\"', '127.0.0.1', '2019-12-17 14:53:18', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (38, 'admin', '新增用户', 66, 'cn.toma.controller.sys.UserController.addUser()', ' user: \"User(userId=19, username=toma, password=8c7bff0667ae2e415ccddf8d3eddcbbb, deptId=10, deptName=null, email=, mobile=, status=1, createTime=Tue Dec 17 14:57:08 CST 2019, modifyTime=null, lastLoginTime=null, ssex=2, description=null, avatar=default.jpg, roleId=1, roleName=null, sortField=null, sortOrder=null, createTimeFrom=null, createTimeTo=null, id=null)\"', '127.0.0.1', '2019-12-17 14:57:08', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (39, 'toma', '修改用户', 63, 'cn.toma.controller.sys.UserController.updateUser()', ' user: \"User(userId=19, username=toma, password=null, deptId=10, deptName=产品部, email=, mobile=, status=1, createTime=null, modifyTime=Tue Dec 17 15:01:39 CST 2019, lastLoginTime=null, ssex=2, description=, avatar=87d8194bc9834e9f8f0228e9e530beb1.jpeg, roleId=1, roleName=管理员, sortField=, sortOrder=, createTimeFrom=, createTimeTo=, id=)\"', '127.0.0.1', '2019-12-17 15:01:40', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (40, 'admin', '删除角色', 215, 'cn.toma.controller.sys.RoleController.deleteRoles()', ' roleIds: \"73\"', '127.0.0.1', '2019-12-17 15:35:23', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (41, 'admin', '删除部门', 262, 'cn.toma.controller.sys.DeptController.deleteDepts()', ' deptIds: \"7\"', '127.0.0.1', '2019-12-17 15:35:50', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (42, 'admin', '修改用户', 57, 'cn.toma.controller.sys.UserController.updateUser()', ' user: \"User(userId=14, username=admin, password=null, deptId=1, deptName=产品部, email=admin@TMBoot.com, mobile=18590809080, status=1, createTime=null, modifyTime=Tue Dec 17 15:40:26 CST 2019, lastLoginTime=null, ssex=0, description=TMBoot, avatar=20180414165840.jpg, roleId=1, roleName=管理员, sortField=, sortOrder=, createTimeFrom=, createTimeTo=, id=)\"', '127.0.0.1', '2019-12-17 15:40:27', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (43, 'admin', '删除登录系统日志', 91, 'cn.toma.controller.sys.LogController.deleteLoginLogs()', ' ids: \"1\"', '127.0.0.1', '2019-12-17 16:36:35', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (44, 'admin', '删除登录系统日志', 24, 'cn.toma.controller.sys.LogController.deleteLoginLogs()', ' ids: \"2\"', '127.0.0.1', '2019-12-17 16:36:40', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (47, 'admin', '删除系统日志', 15, 'cn.toma.controller.sys.LogController.deleteLogss()', ' ids: \"46\"', '127.0.0.1', '2019-12-17 16:37:16', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (48, 'admin', '删除系统日志', 27, 'cn.toma.controller.sys.LogController.deleteLogss()', ' ids: \"1\"', '127.0.0.1', '2019-12-17 16:37:45', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (49, 'admin', '删除系统日志', 22, 'cn.toma.controller.sys.LogController.deleteLogss()', ' ids: \"3,2\"', '127.0.0.1', '2019-12-17 16:38:00', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (50, 'admin', '删除系统日志', 22, 'cn.toma.controller.sys.LogController.deleteLogss()', ' ids: \"4\"', '127.0.0.1', '2019-12-17 16:38:08', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (51, 'admin', '新增菜单/按钮', 93, 'cn.toma.controller.sys.MenuController.addMenu()', ' menu: \"Menu(menuId=169, parentId=3, menuName=在线用户, path=null, component=null, perms=user:online, icon=null, type=1, orderNum=0.0, createTime=Tue Dec 17 17:00:00 CST 2019, modifyTime=null, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-17 17:00:01', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (52, 'admin', '修改角色', 182, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=1, roleName=管理员, remark=管理员, createTime=null, modifyTime=Tue Dec 17 17:00:17 CST 2019, createTimeFrom=, createTimeTo=, menuIds=1,3,11,12,13,130,135,169,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,2,10,24,136,148,149,150,151,152,153,161,162,168)\"', '127.0.0.1', '2019-12-17 17:00:18', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (53, 'admin', '新增菜单/按钮', 15, 'cn.toma.controller.sys.MenuController.addMenu()', ' menu: \"Menu(menuId=170, parentId=2, menuName=在线用户, path=monitor/online, component=febs/monitor/online/Index, perms=user:online, icon=, type=0, orderNum=1.0, createTime=Tue Dec 17 17:23:04 CST 2019, modifyTime=null, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-17 17:23:04', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (54, 'admin', '修改菜单/按钮', 16, 'cn.toma.controller.sys.MenuController.updateMenu()', ' menu: \"Menu(menuId=170, parentId=2, menuName=在线用户, path=/monitor/online, component=febs/monitor/online/Index, perms=user:online, icon=, type=0, orderNum=1.0, createTime=null, modifyTime=Tue Dec 17 17:23:36 CST 2019, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-17 17:23:37', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (55, 'admin', '新增菜单/按钮', 37, 'cn.toma.controller.sys.MenuController.addMenu()', ' menu: \"Menu(menuId=171, parentId=170, menuName=强制下线, path=null, component=null, perms=user:kickout, icon=null, type=1, orderNum=0.0, createTime=Tue Dec 17 17:24:11 CST 2019, modifyTime=null, createTimeFrom=null, createTimeTo=null)\"', '127.0.0.1', '2019-12-17 17:24:11', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (56, 'admin', '修改角色', 182, 'cn.toma.controller.sys.RoleController.updateRole()', ' role: \"Role(roleId=1, roleName=管理员, remark=管理员, createTime=null, modifyTime=Tue Dec 17 17:24:26 CST 2019, createTimeFrom=, createTimeTo=, menuIds=1,3,11,12,13,130,135,169,4,14,15,16,131,5,17,18,19,132,6,20,21,22,133,2,10,24,136,148,149,150,151,152,153,161,162,168,170,171)\"', '127.0.0.1', '2019-12-17 17:24:26', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (57, 'admin', '删除菜单/按钮', 148, 'cn.toma.controller.sys.MenuController.deleteMenus()', ' menuIds: \"169\"', '127.0.0.1', '2019-12-18 09:25:37', '0|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (58, 'admin', '修改用户', 67, 'cn.toma.controller.sys.UserController.updateUser()', ' user: \"User(userId=19, username=toma, password=null, deptId=10, deptName=产品部, email=toma@TMBoot.com, mobile=18590908080, status=1, createTime=null, modifyTime=Wed Dec 18 10:21:50 CST 2019, lastLoginTime=null, ssex=0, description=TMBoot, avatar=87d8194bc9834e9f8f0228e9e530beb1.jpeg, roleId=1, roleName=管理员, sortField=, sortOrder=, createTimeFrom=, createTimeTo=, id=)\"', '127.0.0.1', '2019-12-18 10:21:51', '0|0|0|内网IP|内网IP');
COMMIT;

-- ----------------------------
-- Table structure for t_login_log
-- ----------------------------
DROP TABLE IF EXISTS `t_login_log`;
CREATE TABLE `t_login_log` (
                             `id` int(11) NOT NULL AUTO_INCREMENT,
                             `USERNAME` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
                             `LOGIN_TIME` datetime NOT NULL COMMENT '登录时间',
                             `LOCATION` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '登录地点',
                             `IP` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'IP地址',
                             `system` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '登录系统',
                             `browser` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '登录浏览器',
                             PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_login_log
-- ----------------------------
BEGIN;
INSERT INTO `t_login_log` VALUES (5, 'admin', '2019-09-25 14:26:12', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (6, 'admin', '2019-09-25 14:29:02', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (7, 'admin', '2019-09-25 15:03:23', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (8, 'admin', '2019-12-12 11:56:40', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (9, 'admin', '2019-12-12 11:58:31', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (10, 'admin', '2019-12-12 13:43:41', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (11, 'admin', '2019-12-12 13:57:45', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (12, 'admin', '2019-12-12 14:02:53', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (13, 'admin', '2019-12-12 16:26:24', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (14, 'admin', '2019-12-12 16:27:11', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (15, 'admin', '2019-12-12 16:28:03', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (16, 'admin', '2019-12-12 16:28:48', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (17, 'admin', '2019-12-12 16:29:23', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (18, 'admin', '2019-12-12 16:30:00', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (19, 'admin', '2019-12-12 17:04:28', '0|0|0|内网IP|内网IP', '127.0.0.1', NULL, NULL);
INSERT INTO `t_login_log` VALUES (20, 'admin', '2019-12-12 17:56:43', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (21, 'toma', '2019-12-12 17:59:56', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (22, 'admin', '2019-12-12 18:00:34', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (23, 'admin', '2019-12-16 14:44:24', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (24, 'admin', '2019-12-16 15:43:32', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (25, 'admin', '2019-12-16 16:02:44', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (26, 'admin', '2019-12-16 16:04:02', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (27, 'admin', '2019-12-17 11:23:07', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (28, 'admin', '2019-12-17 11:44:29', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (29, 'toma', '2019-12-17 11:48:54', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (30, 'admin', '2019-12-17 11:52:41', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (31, 'admin', '2019-12-17 14:37:13', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (32, 'admin', '2019-12-17 14:40:57', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (33, 'admin', '2019-12-17 14:41:37', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (34, 'toma', '2019-12-17 14:58:10', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (35, 'toma', '2019-12-17 15:00:37', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (36, 'admin', '2019-12-17 15:02:48', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (37, 'admin', '2019-12-17 15:08:33', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (38, 'admin', '2019-12-17 15:09:57', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (39, 'admin', '2019-12-17 15:12:11', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (40, 'admin', '2019-12-17 15:21:44', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (41, 'toma', '2019-12-17 15:22:22', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (42, 'admin', '2019-12-17 15:31:10', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (43, 'admin', '2019-12-17 15:33:22', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (44, 'admin', '2019-12-17 15:33:54', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (45, 'admin', '2019-12-17 16:42:33', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (46, 'admin', '2019-12-17 16:48:54', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (47, 'admin', '2019-12-17 17:00:31', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (48, 'admin', '2019-12-17 17:24:39', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (49, 'admin', '2019-12-17 17:57:43', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (50, 'admin', '2019-12-18 09:16:06', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (51, 'admin', '2019-12-18 09:16:42', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (52, 'admin', '2019-12-18 10:01:39', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (53, 'admin', '2019-12-18 10:14:13', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (54, 'toma', '2019-12-18 10:22:20', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (55, 'toma', '2019-12-18 10:34:21', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (56, 'admin', '2019-12-18 10:54:48', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (57, 'admin', '2019-12-18 10:56:48', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
INSERT INTO `t_login_log` VALUES (58, 'toma', '2019-12-18 10:59:42', '0|0|0|内网IP|内网IP', '127.0.0.1', 'Mac OS X 10_12_5', 'Chrome 78');
COMMIT;

-- ----------------------------
-- Table structure for t_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
                        `MENU_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单/按钮ID',
                        `PARENT_ID` bigint(20) NOT NULL COMMENT '上级菜单ID',
                        `MENU_NAME` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单/按钮名称',
                        `PATH` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '对应路由path',
                        `COMPONENT` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '对应路由组件component',
                        `PERMS` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限标识',
                        `ICON` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图标',
                        `TYPE` char(2) COLLATE utf8mb4_bin NOT NULL COMMENT '类型 0菜单 1按钮',
                        `ORDER_NUM` double(20,0) DEFAULT NULL COMMENT '排序',
  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`MENU_ID`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_menu` VALUES (1, 0, '系统管理', '/system', 'Layout', NULL, 'el-icon-set-up', '0', 1, '2017-12-27 16:39:07', '2019-07-20 16:19:04');
INSERT INTO `t_menu` VALUES (2, 0, '系统监控', '/monitor', 'Layout', NULL, 'el-icon-data-line', '0', 2, '2017-12-27 16:45:51', '2019-01-23 06:27:12');
INSERT INTO `t_menu` VALUES (3, 1, '用户管理', '/system/user', 'febs/system/user/Index', 'user:view', '', '0', 1, '2017-12-27 16:47:13', '2019-01-22 06:45:55');
INSERT INTO `t_menu` VALUES (4, 1, '角色管理', '/system/role', 'febs/system/role/Index', 'role:view', '', '0', 2, '2017-12-27 16:48:09', '2018-04-25 09:01:12');
INSERT INTO `t_menu` VALUES (5, 1, '菜单管理', '/system/menu', 'febs/system/menu/Index', 'menu:view', '', '0', 3, '2017-12-27 16:48:57', '2018-04-25 09:01:30');
INSERT INTO `t_menu` VALUES (6, 1, '部门管理', '/system/dept', 'febs/system/dept/Index', 'dept:view', '', '0', 4, '2017-12-27 16:57:33', '2018-04-25 09:01:40');
INSERT INTO `t_menu` VALUES (10, 2, '系统日志', '/monitor/systemlog', 'febs/monitor/systemlog/Index', 'log:view', '', '0', 1, '2017-12-27 17:00:50', '2019-07-22 20:22:31');
INSERT INTO `t_menu` VALUES (11, 3, '新增用户', '', '', 'user:add', NULL, '1', 0, '2017-12-27 17:02:58', '2019-12-12 16:18:08');
INSERT INTO `t_menu` VALUES (12, 3, '修改用户', '', '', 'user:update', NULL, '1', NULL, '2017-12-27 17:04:07', NULL);
INSERT INTO `t_menu` VALUES (13, 3, '删除用户', '', '', 'user:delete', NULL, '1', NULL, '2017-12-27 17:04:58', NULL);
INSERT INTO `t_menu` VALUES (14, 4, '新增角色', '', '', 'role:add', NULL, '1', NULL, '2017-12-27 17:06:38', NULL);
INSERT INTO `t_menu` VALUES (15, 4, '修改角色', '', '', 'role:update', NULL, '1', NULL, '2017-12-27 17:06:38', NULL);
INSERT INTO `t_menu` VALUES (16, 4, '删除角色', '', '', 'role:delete', NULL, '1', NULL, '2017-12-27 17:06:38', NULL);
INSERT INTO `t_menu` VALUES (17, 5, '新增菜单', '', '', 'menu:add', NULL, '1', NULL, '2017-12-27 17:08:02', NULL);
INSERT INTO `t_menu` VALUES (18, 5, '修改菜单', '', '', 'menu:update', NULL, '1', NULL, '2017-12-27 17:08:02', NULL);
INSERT INTO `t_menu` VALUES (19, 5, '删除菜单', '', '', 'menu:delete', NULL, '1', NULL, '2017-12-27 17:08:02', NULL);
INSERT INTO `t_menu` VALUES (20, 6, '新增部门', '', '', 'dept:add', NULL, '1', NULL, '2017-12-27 17:09:24', NULL);
INSERT INTO `t_menu` VALUES (21, 6, '修改部门', '', '', 'dept:update', NULL, '1', NULL, '2017-12-27 17:09:24', NULL);
INSERT INTO `t_menu` VALUES (22, 6, '删除部门', '', '', 'dept:delete', NULL, '1', NULL, '2017-12-27 17:09:24', NULL);
INSERT INTO `t_menu` VALUES (24, 10, '删除日志', '', '', 'log:delete', NULL, '1', NULL, '2017-12-27 17:11:45', NULL);
INSERT INTO `t_menu` VALUES (130, 3, '导出Excel', NULL, NULL, 'user:export', NULL, '1', NULL, '2019-01-23 06:35:16', NULL);
INSERT INTO `t_menu` VALUES (131, 4, '导出Excel', NULL, NULL, 'role:export', NULL, '1', NULL, '2019-01-23 06:35:36', NULL);
INSERT INTO `t_menu` VALUES (132, 5, '导出Excel', NULL, NULL, 'menu:export', NULL, '1', NULL, '2019-01-23 06:36:05', NULL);
INSERT INTO `t_menu` VALUES (133, 6, '导出Excel', NULL, NULL, 'dept:export', NULL, '1', NULL, '2019-01-23 06:36:25', NULL);
INSERT INTO `t_menu` VALUES (135, 3, '密码重置', NULL, NULL, 'user:reset', NULL, '1', NULL, '2019-01-23 06:37:00', NULL);
INSERT INTO `t_menu` VALUES (136, 10, '导出Excel', NULL, NULL, 'log:export', NULL, '1', NULL, '2019-01-23 06:37:27', NULL);
INSERT INTO `t_menu` VALUES (148, 2, '监控中心', '/monitor/admin', 'febs/monitor/admin/Index', 'mobitor:admin', '', '0', 6, '2019-07-20 19:42:07', '2019-09-01 10:48:12');
INSERT INTO `t_menu` VALUES (149, 2, '注册中心', 'http://localhost:8001/nacos', 'Layout', 'monitor:register', '', '0', 3, '2019-07-20 20:07:00', '2019-07-22 20:22:43');
INSERT INTO `t_menu` VALUES (150, 2, '登录日志', '/monitor/loginlog', 'febs/monitor/loginlog/Index', 'monitor:loginlog', '', '0', 2, '2019-07-22 13:41:17', '2019-07-22 20:22:35');
INSERT INTO `t_menu` VALUES (151, 150, '删除日志', NULL, NULL, 'loginlog:delete', NULL, '1', NULL, '2019-07-22 13:43:04', NULL);
INSERT INTO `t_menu` VALUES (152, 150, '导出Excel', NULL, NULL, 'loginlog:export', NULL, '1', NULL, '2019-07-22 13:43:30', NULL);
INSERT INTO `t_menu` VALUES (153, 2, '接口文档', '/monitor/swagger', 'febs/monitor/swagger/Index', 'monitor:swagger', '', '0', 7, '2019-07-22 20:59:46', '2019-09-01 10:48:16');
INSERT INTO `t_menu` VALUES (161, 2, '请求追踪', '/monitor/zipkin', 'febs/monitor/zipkin/Index', 'monitor:zipkin', '', '0', 4, '2019-09-01 10:41:49', NULL);
INSERT INTO `t_menu` VALUES (162, 2, '日志收集', '/monitor/kibana', 'febs/monitor/kibana/Index', 'monitor:kibana', '', '0', 5, '2019-09-01 10:48:07', NULL);
INSERT INTO `t_menu` VALUES (168, 2, '百度一下', 'http://www.baidu.com', 'Layout', '', '', '0', 2, '2019-12-12 16:25:33', NULL);
INSERT INTO `t_menu` VALUES (170, 2, '在线用户', '/monitor/online', 'febs/monitor/online/Index', 'user:online', '', '0', 1, '2019-12-17 17:23:04', '2019-12-17 17:23:37');
INSERT INTO `t_menu` VALUES (171, 170, '强制下线', NULL, NULL, 'user:kickout', NULL, '1', 0, '2019-12-17 17:24:11', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
                        `ROLE_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
                        `ROLE_NAME` varchar(10) COLLATE utf8mb4_bin NOT NULL COMMENT '角色名称',
                        `REMARK` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色描述',
                        `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
                        `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间',
                        PRIMARY KEY (`ROLE_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_role
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES (1, '管理员', '管理员', '2017-12-27 16:23:11', '2019-12-17 17:24:26');
INSERT INTO `t_role` VALUES (3, '普通用户', '只可查看，好可怜哦', '2019-01-23 07:33:20', '2019-12-12 15:55:19');
COMMIT;

-- ----------------------------
-- Table structure for t_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_role_menu`;
CREATE TABLE `t_role_menu` (
                             `ROLE_ID` bigint(20) NOT NULL,
                             `MENU_ID` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_role_menu` VALUES (3, 1);
INSERT INTO `t_role_menu` VALUES (3, 3);
INSERT INTO `t_role_menu` VALUES (3, 11);
INSERT INTO `t_role_menu` VALUES (3, 12);
INSERT INTO `t_role_menu` VALUES (3, 13);
INSERT INTO `t_role_menu` VALUES (3, 130);
INSERT INTO `t_role_menu` VALUES (3, 135);
INSERT INTO `t_role_menu` VALUES (3, 4);
INSERT INTO `t_role_menu` VALUES (3, 14);
INSERT INTO `t_role_menu` VALUES (3, 15);
INSERT INTO `t_role_menu` VALUES (3, 16);
INSERT INTO `t_role_menu` VALUES (3, 131);
INSERT INTO `t_role_menu` VALUES (3, 5);
INSERT INTO `t_role_menu` VALUES (3, 17);
INSERT INTO `t_role_menu` VALUES (3, 18);
INSERT INTO `t_role_menu` VALUES (3, 19);
INSERT INTO `t_role_menu` VALUES (3, 132);
INSERT INTO `t_role_menu` VALUES (3, 6);
INSERT INTO `t_role_menu` VALUES (3, 20);
INSERT INTO `t_role_menu` VALUES (3, 21);
INSERT INTO `t_role_menu` VALUES (3, 22);
INSERT INTO `t_role_menu` VALUES (3, 133);
INSERT INTO `t_role_menu` VALUES (3, 163);
INSERT INTO `t_role_menu` VALUES (3, 164);
INSERT INTO `t_role_menu` VALUES (3, 165);
INSERT INTO `t_role_menu` VALUES (3, 166);
INSERT INTO `t_role_menu` VALUES (3, 167);
INSERT INTO `t_role_menu` VALUES (3, 2);
INSERT INTO `t_role_menu` VALUES (3, 10);
INSERT INTO `t_role_menu` VALUES (3, 24);
INSERT INTO `t_role_menu` VALUES (3, 136);
INSERT INTO `t_role_menu` VALUES (3, 148);
INSERT INTO `t_role_menu` VALUES (3, 149);
INSERT INTO `t_role_menu` VALUES (3, 150);
INSERT INTO `t_role_menu` VALUES (3, 151);
INSERT INTO `t_role_menu` VALUES (3, 152);
INSERT INTO `t_role_menu` VALUES (3, 153);
INSERT INTO `t_role_menu` VALUES (1, 1);
INSERT INTO `t_role_menu` VALUES (1, 3);
INSERT INTO `t_role_menu` VALUES (1, 11);
INSERT INTO `t_role_menu` VALUES (1, 12);
INSERT INTO `t_role_menu` VALUES (1, 13);
INSERT INTO `t_role_menu` VALUES (1, 130);
INSERT INTO `t_role_menu` VALUES (1, 135);
INSERT INTO `t_role_menu` VALUES (1, 169);
INSERT INTO `t_role_menu` VALUES (1, 4);
INSERT INTO `t_role_menu` VALUES (1, 14);
INSERT INTO `t_role_menu` VALUES (1, 15);
INSERT INTO `t_role_menu` VALUES (1, 16);
INSERT INTO `t_role_menu` VALUES (1, 131);
INSERT INTO `t_role_menu` VALUES (1, 5);
INSERT INTO `t_role_menu` VALUES (1, 17);
INSERT INTO `t_role_menu` VALUES (1, 18);
INSERT INTO `t_role_menu` VALUES (1, 19);
INSERT INTO `t_role_menu` VALUES (1, 132);
INSERT INTO `t_role_menu` VALUES (1, 6);
INSERT INTO `t_role_menu` VALUES (1, 20);
INSERT INTO `t_role_menu` VALUES (1, 21);
INSERT INTO `t_role_menu` VALUES (1, 22);
INSERT INTO `t_role_menu` VALUES (1, 133);
INSERT INTO `t_role_menu` VALUES (1, 2);
INSERT INTO `t_role_menu` VALUES (1, 10);
INSERT INTO `t_role_menu` VALUES (1, 24);
INSERT INTO `t_role_menu` VALUES (1, 136);
INSERT INTO `t_role_menu` VALUES (1, 148);
INSERT INTO `t_role_menu` VALUES (1, 149);
INSERT INTO `t_role_menu` VALUES (1, 150);
INSERT INTO `t_role_menu` VALUES (1, 151);
INSERT INTO `t_role_menu` VALUES (1, 152);
INSERT INTO `t_role_menu` VALUES (1, 153);
INSERT INTO `t_role_menu` VALUES (1, 161);
INSERT INTO `t_role_menu` VALUES (1, 162);
INSERT INTO `t_role_menu` VALUES (1, 168);
INSERT INTO `t_role_menu` VALUES (1, 170);
INSERT INTO `t_role_menu` VALUES (1, 171);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
                        `USER_ID` bigint(10) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
                        `USERNAME` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
                        `PASSWORD` varchar(128) COLLATE utf8mb4_bin NOT NULL COMMENT '密码',
                        `DEPT_ID` bigint(20) DEFAULT NULL COMMENT '部门ID',
                        `EMAIL` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邮箱',
                        `MOBILE` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系电话',
                        `STATUS` char(1) COLLATE utf8mb4_bin NOT NULL COMMENT '状态 0锁定 1有效',
                        `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
                        `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间',
                        `LAST_LOGIN_TIME` datetime DEFAULT NULL COMMENT '最近访问时间',
                        `SSEX` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '性别 0男 1女 2保密',
                        `DESCRIPTION` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '描述',
                        `AVATAR` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户头像',
                        `THEME` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '主题',
                        `IS_TAB` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '是否开启tab 0.关闭 1.开启',
                        PRIMARY KEY (`USER_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES (14, 'admin', 'bfc62b3f67a4c3e57df84dad8cc48a3b', 1, 'admin@TMBoot.com', '18590809080', '1', '2019-08-26 11:25:03', '2019-12-17 15:40:27', '2019-12-18 10:56:48', '0', 'TMBoot Author', '20180414165840.jpg', NULL, '0');
INSERT INTO `t_user` VALUES (19, 'toma', '592f82d6fec13ed531f652c87651c018', 10, 'toma@TMBoot.com', '18590908080', '1', '2019-12-17 14:57:08', '2019-12-18 10:21:51', '2019-12-18 10:59:42', '0', 'TMBoot', '87d8194bc9834e9f8f0228e9e530beb1.jpeg', NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
                             `USER_ID` bigint(20) NOT NULL COMMENT '用户ID',
                             `ROLE_ID` bigint(20) NOT NULL COMMENT '角色ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
BEGIN;
INSERT INTO `t_user_role` VALUES (14, 1);
INSERT INTO `t_user_role` VALUES (19, 1);
COMMIT;

-- ----------------------------
-- Function structure for findDeptChildren
-- ----------------------------
DROP FUNCTION IF EXISTS `findDeptChildren`;
delimiter ;;
CREATE FUNCTION `ff_boot_init`.`findDeptChildren`(rootId INT)
RETURNS varchar(4000) CHARSET utf8
BEGIN
DECLARE sTemp VARCHAR(4000);
DECLARE sTempChd VARCHAR(4000);
SET sTemp = '$';
SET sTempChd = CAST(rootId as CHAR);
WHILE sTempChd is not null DO
SET sTemp = CONCAT(sTemp,',',sTempChd);
SELECT GROUP_CONCAT(dept_id) INTO sTempChd FROM t_dept
WHERE FIND_IN_SET(parent_id,sTempChd)>0;
END WHILE;
RETURN sTemp;
END
;;
delimiter ;

-- ----------------------------
-- Function structure for findMenuChildren
-- ----------------------------
DROP FUNCTION IF EXISTS `findMenuChildren`;
delimiter ;;
CREATE FUNCTION `ff_boot_init`.`findMenuChildren`(rootId INT)
RETURNS varchar(4000) CHARSET utf8
BEGIN
DECLARE sTemp VARCHAR(4000);
DECLARE sTempChd VARCHAR(4000);
SET sTemp = '$';
SET sTempChd = CAST(rootId as CHAR);
WHILE sTempChd is not null DO
SET sTemp = CONCAT(sTemp,',',sTempChd);
SELECT GROUP_CONCAT(menu_id) INTO sTempChd FROM t_menu
WHERE FIND_IN_SET(parent_id,sTempChd)>0;
END WHILE;
RETURN sTemp;
END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;
